Best Of

I want to use Power Automate to send a professionally formatted email with Smartsheet data embedded in it. For example, Power Automate would receive the person's name, email, and pre-filled form's link text (instead of a long URL) and compose/send an email. I know Zapier can do this, but our team doesn't want to pay for it.

Does anyone have experience building automations with Power Automate and the coding for composing json arrays and parsing jsons for emails? Any resources someone could point me to? If I figure out how to do it I will share on this thread.

Hi @Lieueez

Though not professionally formatted, I experimented with Power Automate to get data from Smartsheet and send an email using Power Automate's code view feature in the Send an email (v2) action, to answer the following.

As I'm new to Power Automate, I used a combination of Filter Array and Composer to get a column ID.

To get a cell value to use in an email, I first used Filter Array to get the columns.

Then, I used the composer to get the columnID;

first(body('urlColumn'))?['id']

Then, in this example, in the "Apply to each Row(s)" & "For each cell(s)", I checked if a checkbox is checked.

If so, get the cell values using the column ID to get the value.

Again, I used the Filter Array & Composer to get the value.

first(body('SendEmailRowUrlCells'))?['value']

Finally, use the code view feature </> to use those values or Outputs in the Body of an email.